/**
 *Copyright (c) 2024 watereyes
 * safetymanagement is licensed under Mulan PubL v2.
 * You can use this software according to the terms and conditions of the Mulan
 * PubL v2.
 * You may obtain a copy of Mulan PubL v2 at:
 *          http://license.coscl.org.cn/MulanPubL-2.0
 * THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
 * EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
 * MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
 * See the Mulan PubL v2 for more details.
 */
package com.koron.emergency.mapper;

import com.koron.emergency.domain.DrillAssessment;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

public interface DrillAssessmentMapper {
    Integer insert(@Param("bean") DrillAssessment bean);

    Integer delete(@Param("id") String id);

    Integer update(@Param("bean") DrillAssessment bean);

    DrillAssessment queryOne(@Param("id") String id);

    List<DrillAssessment> queryByCondition(@Param("corpCode") String corpCode, @Param("name") String name, @Param("sponsorDeptCode")String sponsorDeptCode,
                                           @Param("drillMethod") Integer drillMethod, @Param("startTime") Date startTime,
                                     @Param("endTime")Date endTime, @Param("start")Integer start, @Param("rows")Integer rows);

    Integer countByCondition(@Param("corpCode") String corpCode,@Param("name") String name, @Param("sponsorDeptCode")String sponsorDeptCode,
                             @Param("drillMethod") Integer drillMethod,@Param("startTime")Date startTime,  @Param("endTime")Date endTime);

    Integer doubleName(@Param("corpCode") String corpCode,@Param("name") String name,@Param("id") String id);
}
